package com.desksoft.ecommerce.entity.mall.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PresentlistExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PresentlistExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andInfoidIsNull() {
            addCriterion("InfoID is null");
            return (Criteria) this;
        }

        public Criteria andInfoidIsNotNull() {
            addCriterion("InfoID is not null");
            return (Criteria) this;
        }

        public Criteria andInfoidEqualTo(Long value) {
            addCriterion("InfoID =", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidNotEqualTo(Long value) {
            addCriterion("InfoID <>", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidGreaterThan(Long value) {
            addCriterion("InfoID >", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidGreaterThanOrEqualTo(Long value) {
            addCriterion("InfoID >=", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidLessThan(Long value) {
            addCriterion("InfoID <", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidLessThanOrEqualTo(Long value) {
            addCriterion("InfoID <=", value, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidIn(List<Long> values) {
            addCriterion("InfoID in", values, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidNotIn(List<Long> values) {
            addCriterion("InfoID not in", values, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidBetween(Long value1, Long value2) {
            addCriterion("InfoID between", value1, value2, "infoid");
            return (Criteria) this;
        }

        public Criteria andInfoidNotBetween(Long value1, Long value2) {
            addCriterion("InfoID not between", value1, value2, "infoid");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andR00201IsNull() {
            addCriterion("R00201 is null");
            return (Criteria) this;
        }

        public Criteria andR00201IsNotNull() {
            addCriterion("R00201 is not null");
            return (Criteria) this;
        }

        public Criteria andR00201EqualTo(String value) {
            addCriterion("R00201 =", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotEqualTo(String value) {
            addCriterion("R00201 <>", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201GreaterThan(String value) {
            addCriterion("R00201 >", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201GreaterThanOrEqualTo(String value) {
            addCriterion("R00201 >=", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201LessThan(String value) {
            addCriterion("R00201 <", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201LessThanOrEqualTo(String value) {
            addCriterion("R00201 <=", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201Like(String value) {
            addCriterion("R00201 like", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotLike(String value) {
            addCriterion("R00201 not like", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201In(List<String> values) {
            addCriterion("R00201 in", values, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotIn(List<String> values) {
            addCriterion("R00201 not in", values, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201Between(String value1, String value2) {
            addCriterion("R00201 between", value1, value2, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotBetween(String value1, String value2) {
            addCriterion("R00201 not between", value1, value2, "r00201");
            return (Criteria) this;
        }

        public Criteria andInnerseqIsNull() {
            addCriterion("InnerSeq is null");
            return (Criteria) this;
        }

        public Criteria andInnerseqIsNotNull() {
            addCriterion("InnerSeq is not null");
            return (Criteria) this;
        }

        public Criteria andInnerseqEqualTo(Integer value) {
            addCriterion("InnerSeq =", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqNotEqualTo(Integer value) {
            addCriterion("InnerSeq <>", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqGreaterThan(Integer value) {
            addCriterion("InnerSeq >", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqGreaterThanOrEqualTo(Integer value) {
            addCriterion("InnerSeq >=", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqLessThan(Integer value) {
            addCriterion("InnerSeq <", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqLessThanOrEqualTo(Integer value) {
            addCriterion("InnerSeq <=", value, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqIn(List<Integer> values) {
            addCriterion("InnerSeq in", values, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqNotIn(List<Integer> values) {
            addCriterion("InnerSeq not in", values, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqBetween(Integer value1, Integer value2) {
            addCriterion("InnerSeq between", value1, value2, "innerseq");
            return (Criteria) this;
        }

        public Criteria andInnerseqNotBetween(Integer value1, Integer value2) {
            addCriterion("InnerSeq not between", value1, value2, "innerseq");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemnameIsNull() {
            addCriterion("ItemName is null");
            return (Criteria) this;
        }

        public Criteria andItemnameIsNotNull() {
            addCriterion("ItemName is not null");
            return (Criteria) this;
        }

        public Criteria andItemnameEqualTo(String value) {
            addCriterion("ItemName =", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameNotEqualTo(String value) {
            addCriterion("ItemName <>", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameGreaterThan(String value) {
            addCriterion("ItemName >", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameGreaterThanOrEqualTo(String value) {
            addCriterion("ItemName >=", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameLessThan(String value) {
            addCriterion("ItemName <", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameLessThanOrEqualTo(String value) {
            addCriterion("ItemName <=", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameLike(String value) {
            addCriterion("ItemName like", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameNotLike(String value) {
            addCriterion("ItemName not like", value, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameIn(List<String> values) {
            addCriterion("ItemName in", values, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameNotIn(List<String> values) {
            addCriterion("ItemName not in", values, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameBetween(String value1, String value2) {
            addCriterion("ItemName between", value1, value2, "itemname");
            return (Criteria) this;
        }

        public Criteria andItemnameNotBetween(String value1, String value2) {
            addCriterion("ItemName not between", value1, value2, "itemname");
            return (Criteria) this;
        }

        public Criteria andStandardIsNull() {
            addCriterion("Standard is null");
            return (Criteria) this;
        }

        public Criteria andStandardIsNotNull() {
            addCriterion("Standard is not null");
            return (Criteria) this;
        }

        public Criteria andStandardEqualTo(String value) {
            addCriterion("Standard =", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotEqualTo(String value) {
            addCriterion("Standard <>", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThan(String value) {
            addCriterion("Standard >", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThanOrEqualTo(String value) {
            addCriterion("Standard >=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThan(String value) {
            addCriterion("Standard <", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThanOrEqualTo(String value) {
            addCriterion("Standard <=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLike(String value) {
            addCriterion("Standard like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotLike(String value) {
            addCriterion("Standard not like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardIn(List<String> values) {
            addCriterion("Standard in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotIn(List<String> values) {
            addCriterion("Standard not in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardBetween(String value1, String value2) {
            addCriterion("Standard between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotBetween(String value1, String value2) {
            addCriterion("Standard not between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("Unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("Unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("Unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("Unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("Unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("Unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("Unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("Unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("Unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("Unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("Unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("Unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("Unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("Unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andDistpackIsNull() {
            addCriterion("DistPack is null");
            return (Criteria) this;
        }

        public Criteria andDistpackIsNotNull() {
            addCriterion("DistPack is not null");
            return (Criteria) this;
        }

        public Criteria andDistpackEqualTo(BigDecimal value) {
            addCriterion("DistPack =", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackNotEqualTo(BigDecimal value) {
            addCriterion("DistPack <>", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackGreaterThan(BigDecimal value) {
            addCriterion("DistPack >", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DistPack >=", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackLessThan(BigDecimal value) {
            addCriterion("DistPack <", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DistPack <=", value, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackIn(List<BigDecimal> values) {
            addCriterion("DistPack in", values, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackNotIn(List<BigDecimal> values) {
            addCriterion("DistPack not in", values, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistPack between", value1, value2, "distpack");
            return (Criteria) this;
        }

        public Criteria andDistpackNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistPack not between", value1, value2, "distpack");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNull() {
            addCriterion("SalePrice is null");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNotNull() {
            addCriterion("SalePrice is not null");
            return (Criteria) this;
        }

        public Criteria andSalepriceEqualTo(BigDecimal value) {
            addCriterion("SalePrice =", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotEqualTo(BigDecimal value) {
            addCriterion("SalePrice <>", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThan(BigDecimal value) {
            addCriterion("SalePrice >", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SalePrice >=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThan(BigDecimal value) {
            addCriterion("SalePrice <", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SalePrice <=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceIn(List<BigDecimal> values) {
            addCriterion("SalePrice in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotIn(List<BigDecimal> values) {
            addCriterion("SalePrice not in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SalePrice between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SalePrice not between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andStockqtyIsNull() {
            addCriterion("StockQty is null");
            return (Criteria) this;
        }

        public Criteria andStockqtyIsNotNull() {
            addCriterion("StockQty is not null");
            return (Criteria) this;
        }

        public Criteria andStockqtyEqualTo(BigDecimal value) {
            addCriterion("StockQty =", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyNotEqualTo(BigDecimal value) {
            addCriterion("StockQty <>", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyGreaterThan(BigDecimal value) {
            addCriterion("StockQty >", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("StockQty >=", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyLessThan(BigDecimal value) {
            addCriterion("StockQty <", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("StockQty <=", value, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyIn(List<BigDecimal> values) {
            addCriterion("StockQty in", values, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyNotIn(List<BigDecimal> values) {
            addCriterion("StockQty not in", values, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("StockQty between", value1, value2, "stockqty");
            return (Criteria) this;
        }

        public Criteria andStockqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("StockQty not between", value1, value2, "stockqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIsNull() {
            addCriterion("AcceptQty is null");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIsNotNull() {
            addCriterion("AcceptQty is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyEqualTo(BigDecimal value) {
            addCriterion("AcceptQty =", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotEqualTo(BigDecimal value) {
            addCriterion("AcceptQty <>", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyGreaterThan(BigDecimal value) {
            addCriterion("AcceptQty >", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptQty >=", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyLessThan(BigDecimal value) {
            addCriterion("AcceptQty <", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptQty <=", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIn(List<BigDecimal> values) {
            addCriterion("AcceptQty in", values, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotIn(List<BigDecimal> values) {
            addCriterion("AcceptQty not in", values, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptQty between", value1, value2, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptQty not between", value1, value2, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyIsNull() {
            addCriterion("OnQty is null");
            return (Criteria) this;
        }

        public Criteria andOnqtyIsNotNull() {
            addCriterion("OnQty is not null");
            return (Criteria) this;
        }

        public Criteria andOnqtyEqualTo(BigDecimal value) {
            addCriterion("OnQty =", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyNotEqualTo(BigDecimal value) {
            addCriterion("OnQty <>", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyGreaterThan(BigDecimal value) {
            addCriterion("OnQty >", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("OnQty >=", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyLessThan(BigDecimal value) {
            addCriterion("OnQty <", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("OnQty <=", value, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyIn(List<BigDecimal> values) {
            addCriterion("OnQty in", values, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyNotIn(List<BigDecimal> values) {
            addCriterion("OnQty not in", values, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OnQty between", value1, value2, "onqty");
            return (Criteria) this;
        }

        public Criteria andOnqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OnQty not between", value1, value2, "onqty");
            return (Criteria) this;
        }

        public Criteria andQty0IsNull() {
            addCriterion("Qty0 is null");
            return (Criteria) this;
        }

        public Criteria andQty0IsNotNull() {
            addCriterion("Qty0 is not null");
            return (Criteria) this;
        }

        public Criteria andQty0EqualTo(BigDecimal value) {
            addCriterion("Qty0 =", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0NotEqualTo(BigDecimal value) {
            addCriterion("Qty0 <>", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0GreaterThan(BigDecimal value) {
            addCriterion("Qty0 >", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty0 >=", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0LessThan(BigDecimal value) {
            addCriterion("Qty0 <", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty0 <=", value, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0In(List<BigDecimal> values) {
            addCriterion("Qty0 in", values, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0NotIn(List<BigDecimal> values) {
            addCriterion("Qty0 not in", values, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty0 between", value1, value2, "qty0");
            return (Criteria) this;
        }

        public Criteria andQty0NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty0 not between", value1, value2, "qty0");
            return (Criteria) this;
        }

        public Criteria andValueIsNull() {
            addCriterion("Value is null");
            return (Criteria) this;
        }

        public Criteria andValueIsNotNull() {
            addCriterion("Value is not null");
            return (Criteria) this;
        }

        public Criteria andValueEqualTo(BigDecimal value) {
            addCriterion("Value =", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotEqualTo(BigDecimal value) {
            addCriterion("Value <>", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueGreaterThan(BigDecimal value) {
            addCriterion("Value >", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Value >=", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueLessThan(BigDecimal value) {
            addCriterion("Value <", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Value <=", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueIn(List<BigDecimal> values) {
            addCriterion("Value in", values, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotIn(List<BigDecimal> values) {
            addCriterion("Value not in", values, "value");
            return (Criteria) this;
        }

        public Criteria andValueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Value between", value1, value2, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Value not between", value1, value2, "value");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andSeleIsNull() {
            addCriterion("Sele is null");
            return (Criteria) this;
        }

        public Criteria andSeleIsNotNull() {
            addCriterion("Sele is not null");
            return (Criteria) this;
        }

        public Criteria andSeleEqualTo(String value) {
            addCriterion("Sele =", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleNotEqualTo(String value) {
            addCriterion("Sele <>", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleGreaterThan(String value) {
            addCriterion("Sele >", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleGreaterThanOrEqualTo(String value) {
            addCriterion("Sele >=", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleLessThan(String value) {
            addCriterion("Sele <", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleLessThanOrEqualTo(String value) {
            addCriterion("Sele <=", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleLike(String value) {
            addCriterion("Sele like", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleNotLike(String value) {
            addCriterion("Sele not like", value, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleIn(List<String> values) {
            addCriterion("Sele in", values, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleNotIn(List<String> values) {
            addCriterion("Sele not in", values, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleBetween(String value1, String value2) {
            addCriterion("Sele between", value1, value2, "sele");
            return (Criteria) this;
        }

        public Criteria andSeleNotBetween(String value1, String value2) {
            addCriterion("Sele not between", value1, value2, "sele");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("Qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("Qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(BigDecimal value) {
            addCriterion("Qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(BigDecimal value) {
            addCriterion("Qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(BigDecimal value) {
            addCriterion("Qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(BigDecimal value) {
            addCriterion("Qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<BigDecimal> values) {
            addCriterion("Qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<BigDecimal> values) {
            addCriterion("Qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andSysdateIsNull() {
            addCriterion("SysDate is null");
            return (Criteria) this;
        }

        public Criteria andSysdateIsNotNull() {
            addCriterion("SysDate is not null");
            return (Criteria) this;
        }

        public Criteria andSysdateEqualTo(Date value) {
            addCriterion("SysDate =", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotEqualTo(Date value) {
            addCriterion("SysDate <>", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateGreaterThan(Date value) {
            addCriterion("SysDate >", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateGreaterThanOrEqualTo(Date value) {
            addCriterion("SysDate >=", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateLessThan(Date value) {
            addCriterion("SysDate <", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateLessThanOrEqualTo(Date value) {
            addCriterion("SysDate <=", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateIn(List<Date> values) {
            addCriterion("SysDate in", values, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotIn(List<Date> values) {
            addCriterion("SysDate not in", values, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateBetween(Date value1, Date value2) {
            addCriterion("SysDate between", value1, value2, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotBetween(Date value1, Date value2) {
            addCriterion("SysDate not between", value1, value2, "sysdate");
            return (Criteria) this;
        }

        public Criteria andItemtypeIsNull() {
            addCriterion("ItemType is null");
            return (Criteria) this;
        }

        public Criteria andItemtypeIsNotNull() {
            addCriterion("ItemType is not null");
            return (Criteria) this;
        }

        public Criteria andItemtypeEqualTo(String value) {
            addCriterion("ItemType =", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotEqualTo(String value) {
            addCriterion("ItemType <>", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeGreaterThan(String value) {
            addCriterion("ItemType >", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemType >=", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLessThan(String value) {
            addCriterion("ItemType <", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLessThanOrEqualTo(String value) {
            addCriterion("ItemType <=", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLike(String value) {
            addCriterion("ItemType like", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotLike(String value) {
            addCriterion("ItemType not like", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeIn(List<String> values) {
            addCriterion("ItemType in", values, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotIn(List<String> values) {
            addCriterion("ItemType not in", values, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeBetween(String value1, String value2) {
            addCriterion("ItemType between", value1, value2, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotBetween(String value1, String value2) {
            addCriterion("ItemType not between", value1, value2, "itemtype");
            return (Criteria) this;
        }

        public Criteria andBillamtIsNull() {
            addCriterion("BillAmt is null");
            return (Criteria) this;
        }

        public Criteria andBillamtIsNotNull() {
            addCriterion("BillAmt is not null");
            return (Criteria) this;
        }

        public Criteria andBillamtEqualTo(BigDecimal value) {
            addCriterion("BillAmt =", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotEqualTo(BigDecimal value) {
            addCriterion("BillAmt <>", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtGreaterThan(BigDecimal value) {
            addCriterion("BillAmt >", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BillAmt >=", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtLessThan(BigDecimal value) {
            addCriterion("BillAmt <", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BillAmt <=", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtIn(List<BigDecimal> values) {
            addCriterion("BillAmt in", values, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotIn(List<BigDecimal> values) {
            addCriterion("BillAmt not in", values, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BillAmt between", value1, value2, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BillAmt not between", value1, value2, "billamt");
            return (Criteria) this;
        }

        public Criteria andValuexpIsNull() {
            addCriterion("ValueXp is null");
            return (Criteria) this;
        }

        public Criteria andValuexpIsNotNull() {
            addCriterion("ValueXp is not null");
            return (Criteria) this;
        }

        public Criteria andValuexpEqualTo(BigDecimal value) {
            addCriterion("ValueXp =", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpNotEqualTo(BigDecimal value) {
            addCriterion("ValueXp <>", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpGreaterThan(BigDecimal value) {
            addCriterion("ValueXp >", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ValueXp >=", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpLessThan(BigDecimal value) {
            addCriterion("ValueXp <", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ValueXp <=", value, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpIn(List<BigDecimal> values) {
            addCriterion("ValueXp in", values, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpNotIn(List<BigDecimal> values) {
            addCriterion("ValueXp not in", values, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ValueXp between", value1, value2, "valuexp");
            return (Criteria) this;
        }

        public Criteria andValuexpNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ValueXp not between", value1, value2, "valuexp");
            return (Criteria) this;
        }

        public Criteria andDeductionIsNull() {
            addCriterion("Deduction is null");
            return (Criteria) this;
        }

        public Criteria andDeductionIsNotNull() {
            addCriterion("Deduction is not null");
            return (Criteria) this;
        }

        public Criteria andDeductionEqualTo(BigDecimal value) {
            addCriterion("Deduction =", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionNotEqualTo(BigDecimal value) {
            addCriterion("Deduction <>", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionGreaterThan(BigDecimal value) {
            addCriterion("Deduction >", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Deduction >=", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionLessThan(BigDecimal value) {
            addCriterion("Deduction <", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Deduction <=", value, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionIn(List<BigDecimal> values) {
            addCriterion("Deduction in", values, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionNotIn(List<BigDecimal> values) {
            addCriterion("Deduction not in", values, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Deduction between", value1, value2, "deduction");
            return (Criteria) this;
        }

        public Criteria andDeductionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Deduction not between", value1, value2, "deduction");
            return (Criteria) this;
        }

        public Criteria andRchar2IsNull() {
            addCriterion("RChar2 is null");
            return (Criteria) this;
        }

        public Criteria andRchar2IsNotNull() {
            addCriterion("RChar2 is not null");
            return (Criteria) this;
        }

        public Criteria andRchar2EqualTo(String value) {
            addCriterion("RChar2 =", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2NotEqualTo(String value) {
            addCriterion("RChar2 <>", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2GreaterThan(String value) {
            addCriterion("RChar2 >", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2GreaterThanOrEqualTo(String value) {
            addCriterion("RChar2 >=", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2LessThan(String value) {
            addCriterion("RChar2 <", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2LessThanOrEqualTo(String value) {
            addCriterion("RChar2 <=", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2Like(String value) {
            addCriterion("RChar2 like", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2NotLike(String value) {
            addCriterion("RChar2 not like", value, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2In(List<String> values) {
            addCriterion("RChar2 in", values, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2NotIn(List<String> values) {
            addCriterion("RChar2 not in", values, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2Between(String value1, String value2) {
            addCriterion("RChar2 between", value1, value2, "rchar2");
            return (Criteria) this;
        }

        public Criteria andRchar2NotBetween(String value1, String value2) {
            addCriterion("RChar2 not between", value1, value2, "rchar2");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}